/*
 * Copyright (c) 2011 Imre Fazekas.
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   Redistributions of source code must retain the above copyright notice, this
 *   list of conditions and the following disclaimer.
 *
 *   Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation
 *   and/or other materials provided with the distribution.
 *
 *   Neither the name of the Wit-In Comp Inc. nor the names of its
 *   contributors may be used to endorse or promote products derived from this
 *   software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package com.acme.creditblue;

import com.vii.brillien.core.component.SuperPresence;
import com.vii.brillien.kernel.BrillienException;
import com.vii.brillien.kernel.annotations.PresenceService;
import com.vii.brillien.kernel.annotations.lifecycle.Consonant;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/*
    Brillien entity providing customer data.   
 */
@PresenceService( logLevel = PresenceService.FINER )
@Consonant
public class CustomerDataProvider extends SuperPresence {

    private Connection c;

    @Override
    public void plan() throws BrillienException {
        c = getConnection("CustomerDataConnector");
    }

    public boolean validateCustomerData( String name, String accountNumber ) throws BrillienException {
        PreparedStatement pst = null;
        ResultSet r = null;
        try {
            pst = c.prepareStatement(
                "SELECT c.id FROM client AS c WHERE c.\"name\"= ? AND c.id IN (SELECT a.owner_id FROM account AS a WHERE a.id=?);"
            );
            pst.setString( 1, name );
            pst.setString( 2, accountNumber );
            r = pst.executeQuery();
            boolean b = r.next();
            return b;
        } catch (SQLException e) {
            throw new BrillienException( e );
        } finally {
            try {
                r.close(); pst.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

}
